<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!-- NewPage -->
<html lang="en">
<head>
<title>Uses of Interface org.apache.poi.ss.formula.functions.Function (POI API Documentation)</title>
<link rel="stylesheet" type="text/css" href="../../../../../../../stylesheet.css" title="Style">
</head>
<body>
<script type="text/javascript"><!--
    if (location.href.indexOf('is-external=true') == -1) {
        parent.document.title="Uses of Interface org.apache.poi.ss.formula.functions.Function (POI API Documentation)";
    }
//-->
</script>
<noscript>
<div>JavaScript is disabled on your browser.</div>
</noscript>
<!-- ========= START OF TOP NAVBAR ======= -->
<div class="topNav"><a name="navbar_top">
<!--   -->
</a><a href="#skip-navbar_top" title="Skip navigation links"></a><a name="navbar_top_firstrow">
<!--   -->
</a>
<ul class="navList" title="Navigation">
<li><a href="../../../../../../../overview-summary.html">Overview</a></li>
<li><a href="../package-summary.html">Package</a></li>
<li><a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Class</a></li>
<li class="navBarCell1Rev">Use</li>
<li><a href="../package-tree.html">Tree</a></li>
<li><a href="../../../../../../../deprecated-list.html">Deprecated</a></li>
<li><a href="../../../../../../../index-all.html">Index</a></li>
<li><a href="../../../../../../../help-doc.html">Help</a></li>
</ul>
</div>
<div class="subNav">
<ul class="navList">
<li>PREV</li>
<li>NEXT</li>
</ul>
<ul class="navList">
<li><a href="../../../../../../../index.html?org/apache/poi/ss/formula/functions//class-useFunction.html" target="_top">FRAMES</a></li>
<li><a href="Function.html" target="_top">NO FRAMES</a></li>
</ul>
<ul class="navList" id="allclasses_navbar_top">
<li><a href="../../../../../../../allclasses-noframe.html">All Classes</a></li>
</ul>
<div>
<script type="text/javascript"><!--
  allClassesLink = document.getElementById("allclasses_navbar_top");
  if(window==top) {
    allClassesLink.style.display = "block";
  }
  else {
    allClassesLink.style.display = "none";
  }
  //-->
</script>
</div>
<a name="skip-navbar_top">
<!--   -->
</a></div>
<!-- ========= END OF TOP NAVBAR ========= -->
<div class="header">
<h2 title="Uses of Interface org.apache.poi.ss.formula.functions.Function" class="title">Uses of Interface<br>org.apache.poi.ss.formula.functions.Function</h2>
</div>
<div class="classUseContainer">
<ul class="blockList">
<li class="blockList">
<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing packages, and an explanation">
<caption><span>Packages that use <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colFirst" scope="col">Package</th>
<th class="colLast" scope="col">Description</th>
</tr>
<tbody>
<tr class="altColor">
<td class="colFirst"><a href="#org.apache.poi.ss.formula">org.apache.poi.ss.formula</a></td>
<td class="colLast">
<div class="block">This package contains common internal POI code for manipulating formulas.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><a href="#org.apache.poi.ss.formula.eval">org.apache.poi.ss.formula.eval</a></td>
<td class="colLast">&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><a href="#org.apache.poi.ss.formula.functions">org.apache.poi.ss.formula.functions</a></td>
<td class="colLast">&nbsp;</td>
</tr>
</tbody>
</table>
</li>
<li class="blockList">
<ul class="blockList">
<li class="blockList"><a name="org.apache.poi.ss.formula">
<!--   -->
</a>
<h3>Uses of <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a> in <a href="../../../../../../../org/apache/poi/ss/formula/package-summary.html">org.apache.poi.ss.formula</a></h3>
<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing methods, and an explanation">
<caption><span>Methods in <a href="../../../../../../../org/apache/poi/ss/formula/package-summary.html">org.apache.poi.ss.formula</a> with parameters of type <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colFirst" scope="col">Modifier and Type</th>
<th class="colLast" scope="col">Method and Description</th>
</tr>
<tbody>
<tr class="altColor">
<td class="colFirst"><code>static void</code></td>
<td class="colLast"><span class="strong">WorkbookEvaluator.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/WorkbookEvaluator.html#registerFunction(java.lang.String, org.apache.poi.ss.formula.functions.Function)">registerFunction</a></strong>(java.lang.String&nbsp;name,
                <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a>&nbsp;func)</code>
<div class="block">Register a function in runtime.</div>
</td>
</tr>
</tbody>
</table>
</li>
<li class="blockList"><a name="org.apache.poi.ss.formula.eval">
<!--   -->
</a>
<h3>Uses of <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a> in <a href="../../../../../../../org/apache/poi/ss/formula/eval/package-summary.html">org.apache.poi.ss.formula.eval</a></h3>
<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing classes, and an explanation">
<caption><span>Classes in <a href="../../../../../../../org/apache/poi/ss/formula/eval/package-summary.html">org.apache.poi.ss.formula.eval</a> that implement <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colFirst" scope="col">Modifier and Type</th>
<th class="colLast" scope="col">Class and Description</th>
</tr>
<tbody>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/eval/ConcatEval.html" title="class in org.apache.poi.ss.formula.eval">ConcatEval</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/eval/IntersectionEval.html" title="class in org.apache.poi.ss.formula.eval">IntersectionEval</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/eval/PercentEval.html" title="class in org.apache.poi.ss.formula.eval">PercentEval</a></strong></code>
<div class="block">Implementation of Excel formula token '%'.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/eval/RangeEval.html" title="class in org.apache.poi.ss.formula.eval">RangeEval</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/eval/RelationalOperationEval.html" title="class in org.apache.poi.ss.formula.eval">RelationalOperationEval</a></strong></code>
<div class="block">Base class for all comparison operator evaluators</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/eval/TwoOperandNumericOperation.html" title="class in org.apache.poi.ss.formula.eval">TwoOperandNumericOperation</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/eval/UnaryMinusEval.html" title="class in org.apache.poi.ss.formula.eval">UnaryMinusEval</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/eval/UnaryPlusEval.html" title="class in org.apache.poi.ss.formula.eval">UnaryPlusEval</a></strong></code>&nbsp;</td>
</tr>
</tbody>
</table>
<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing fields, and an explanation">
<caption><span>Fields in <a href="../../../../../../../org/apache/poi/ss/formula/eval/package-summary.html">org.apache.poi.ss.formula.eval</a> declared as <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colFirst" scope="col">Modifier and Type</th>
<th class="colLast" scope="col">Field and Description</th>
</tr>
<tbody>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">TwoOperandNumericOperation.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/eval/TwoOperandNumericOperation.html#AddEval">AddEval</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">TwoOperandNumericOperation.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/eval/TwoOperandNumericOperation.html#DivideEval">DivideEval</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">RelationalOperationEval.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/eval/RelationalOperationEval.html#EqualEval">EqualEval</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>protected static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a>[]</code></td>
<td class="colLast"><span class="strong">FunctionEval.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/eval/FunctionEval.html#functions">functions</a></strong></code>
<div class="block">Array elements corresponding to unimplemented functions are <code>null</code></div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">RelationalOperationEval.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/eval/RelationalOperationEval.html#GreaterEqualEval">GreaterEqualEval</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">RelationalOperationEval.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/eval/RelationalOperationEval.html#GreaterThanEval">GreaterThanEval</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">PercentEval.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/eval/PercentEval.html#instance">instance</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">RangeEval.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/eval/RangeEval.html#instance">instance</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">ConcatEval.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/eval/ConcatEval.html#instance">instance</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">UnaryMinusEval.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/eval/UnaryMinusEval.html#instance">instance</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">IntersectionEval.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/eval/IntersectionEval.html#instance">instance</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">UnaryPlusEval.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/eval/UnaryPlusEval.html#instance">instance</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">RelationalOperationEval.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/eval/RelationalOperationEval.html#LessEqualEval">LessEqualEval</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">RelationalOperationEval.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/eval/RelationalOperationEval.html#LessThanEval">LessThanEval</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">TwoOperandNumericOperation.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/eval/TwoOperandNumericOperation.html#MultiplyEval">MultiplyEval</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">RelationalOperationEval.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/eval/RelationalOperationEval.html#NotEqualEval">NotEqualEval</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">TwoOperandNumericOperation.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/eval/TwoOperandNumericOperation.html#PowerEval">PowerEval</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">TwoOperandNumericOperation.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/eval/TwoOperandNumericOperation.html#SubtractEval">SubtractEval</a></strong></code>&nbsp;</td>
</tr>
</tbody>
</table>
<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing methods, and an explanation">
<caption><span>Methods in <a href="../../../../../../../org/apache/poi/ss/formula/eval/package-summary.html">org.apache.poi.ss.formula.eval</a> that return <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colFirst" scope="col">Modifier and Type</th>
<th class="colLast" scope="col">Method and Description</th>
</tr>
<tbody>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">FunctionEval.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/eval/FunctionEval.html#getBasicFunction(int)">getBasicFunction</a></strong>(int&nbsp;functionIndex)</code>&nbsp;</td>
</tr>
</tbody>
</table>
<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing methods, and an explanation">
<caption><span>Methods in <a href="../../../../../../../org/apache/poi/ss/formula/eval/package-summary.html">org.apache.poi.ss.formula.eval</a> with parameters of type <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colFirst" scope="col">Modifier and Type</th>
<th class="colLast" scope="col">Method and Description</th>
</tr>
<tbody>
<tr class="altColor">
<td class="colFirst"><code>static void</code></td>
<td class="colLast"><span class="strong">FunctionEval.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/eval/FunctionEval.html#registerFunction(java.lang.String, org.apache.poi.ss.formula.functions.Function)">registerFunction</a></strong>(java.lang.String&nbsp;name,
                <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a>&nbsp;func)</code>
<div class="block">Register a new function in runtime.</div>
</td>
</tr>
</tbody>
</table>
</li>
<li class="blockList"><a name="org.apache.poi.ss.formula.functions">
<!--   -->
</a>
<h3>Uses of <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a> in <a href="../../../../../../../org/apache/poi/ss/formula/functions/package-summary.html">org.apache.poi.ss.formula.functions</a></h3>
<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing subinterfaces, and an explanation">
<caption><span>Subinterfaces of <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a> in <a href="../../../../../../../org/apache/poi/ss/formula/functions/package-summary.html">org.apache.poi.ss.formula.functions</a></span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colFirst" scope="col">Modifier and Type</th>
<th class="colLast" scope="col">Interface and Description</th>
</tr>
<tbody>
<tr class="altColor">
<td class="colFirst"><code>interface&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Function0Arg.html" title="interface in org.apache.poi.ss.formula.functions">Function0Arg</a></strong></code>
<div class="block">Implemented by all functions that can be called with zero arguments</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>interface&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Function1Arg.html" title="interface in org.apache.poi.ss.formula.functions">Function1Arg</a></strong></code>
<div class="block">Implemented by all functions that can be called with one argument</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>interface&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Function2Arg.html" title="interface in org.apache.poi.ss.formula.functions">Function2Arg</a></strong></code>
<div class="block">Implemented by all functions that can be called with two arguments</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>interface&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Function3Arg.html" title="interface in org.apache.poi.ss.formula.functions">Function3Arg</a></strong></code>
<div class="block">Implemented by all functions that can be called with three arguments</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>interface&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Function4Arg.html" title="interface in org.apache.poi.ss.formula.functions">Function4Arg</a></strong></code>
<div class="block">Implemented by all functions that can be called with four arguments</div>
</td>
</tr>
</tbody>
</table>
<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing classes, and an explanation">
<caption><span>Classes in <a href="../../../../../../../org/apache/poi/ss/formula/functions/package-summary.html">org.apache.poi.ss.formula.functions</a> that implement <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colFirst" scope="col">Modifier and Type</th>
<th class="colLast" scope="col">Class and Description</th>
</tr>
<tbody>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Address.html" title="class in org.apache.poi.ss.formula.functions">Address</a></strong></code>
<div class="block">Creates a text reference as text, given specified row and column numbers.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/AggregateFunction.html" title="class in org.apache.poi.ss.formula.functions">AggregateFunction</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Bin2Dec.html" title="class in org.apache.poi.ss.formula.functions">Bin2Dec</a></strong></code>
<div class="block">Implementation for Excel Bin2Dec() function.<p/>
 <p/>
 <b>Syntax</b>:<br/> <b>Bin2Dec  </b>(<b>number</b>)<br/>
 <p/>
 Converts a binary number to decimal.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/BooleanFunction.html" title="class in org.apache.poi.ss.formula.functions">BooleanFunction</a></strong></code>
<div class="block">Here are the general rules concerning Boolean functions:
 
  Blanks are ignored (not either true or false) 
  Strings are ignored if part of an area ref or cell ref, otherwise they must be 'true' or 'false'
  Numbers: 0 is false.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/CalendarFieldFunction.html" title="class in org.apache.poi.ss.formula.functions">CalendarFieldFunction</a></strong></code>
<div class="block">Implementation of Excel functions Date parsing functions:
  Date - DAY, MONTH and YEAR
  Time - HOUR, MINUTE and SECOND</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Choose.html" title="class in org.apache.poi.ss.formula.functions">Choose</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Code.html" title="class in org.apache.poi.ss.formula.functions">Code</a></strong></code>
<div class="block">Implementation for Excel CODE () function.<p/>
 <p/>
 <b>Syntax</b>:<br/> <b>CODE   </b>(<b>text</b> )<br/>
 <p/>
 Returns a numeric code for the first character in a text string.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Column.html" title="class in org.apache.poi.ss.formula.functions">Column</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Columns.html" title="class in org.apache.poi.ss.formula.functions">Columns</a></strong></code>
<div class="block">Implementation for Excel COLUMNS function.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Complex.html" title="class in org.apache.poi.ss.formula.functions">Complex</a></strong></code>
<div class="block">Implementation for Excel COMPLEX () function.<p/>
 <p/>
 <b>Syntax</b>:<br/> <b>COMPLEX   </b>(<b>real_num</b>,<b>i_num</b>,<b>suffix </b> )<br/>
 <p/>
 Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Count.html" title="class in org.apache.poi.ss.formula.functions">Count</a></strong></code>
<div class="block">Counts the number of cells that contain numeric data within
  the list of arguments.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Counta.html" title="class in org.apache.poi.ss.formula.functions">Counta</a></strong></code>
<div class="block">Counts the number of cells that contain data within the list of arguments.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Countblank.html" title="class in org.apache.poi.ss.formula.functions">Countblank</a></strong></code>
<div class="block">Implementation for the function COUNTBLANK</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Countif.html" title="class in org.apache.poi.ss.formula.functions">Countif</a></strong></code>
<div class="block">Implementation for the function COUNTIF</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/DateFunc.html" title="class in org.apache.poi.ss.formula.functions">DateFunc</a></strong></code>
<div class="block">Implementation for the Excel function DATE</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Days360.html" title="class in org.apache.poi.ss.formula.functions">Days360</a></strong></code>
<div class="block">Calculates the number of days between two dates based on a 360-day year
 (twelve 30-day months), which is used in some accounting calculations.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Dec2Bin.html" title="class in org.apache.poi.ss.formula.functions">Dec2Bin</a></strong></code>
<div class="block">Implementation for Excel Bin2Dec() function.<p/>
 <p/>
 <b>Syntax</b>:<br/> <b>Bin2Dec  </b>(<b>number</b>,<b>[places]</b> )<br/>
 <p/>
 Converts a decimal number to binary.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Dec2Hex.html" title="class in org.apache.poi.ss.formula.functions">Dec2Hex</a></strong></code>
<div class="block">Implementation for Excel DELTA() function.<p/>
 <p/>
 <b>Syntax</b>:<br/> <b>DEC2HEX  </b>(<b>number</b>,<b>places</b> )<br/>
 <p/>
 Converts a decimal number to hexadecimal.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Delta.html" title="class in org.apache.poi.ss.formula.functions">Delta</a></strong></code>
<div class="block">Implementation for Excel DELTA() function.<p/>
 <p/>
 <b>Syntax</b>:<br/> <b>DELTA </b>(<b>number1</b>,<b>number2</b> )<br/>
 <p/>
 Tests whether two values are equal.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Errortype.html" title="class in org.apache.poi.ss.formula.functions">Errortype</a></strong></code>
<div class="block">Implementation for the ERROR.TYPE() Excel function.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Even.html" title="class in org.apache.poi.ss.formula.functions">Even</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/FactDouble.html" title="class in org.apache.poi.ss.formula.functions">FactDouble</a></strong></code>
<div class="block">Implementation for Excel FACTDOUBLE() function.<p/>
 <p/>
 <b>Syntax</b>:<br/> <b>FACTDOUBLE  </b>(<b>number</b>)<br/>
 <p/>
 Returns the double factorial of a number.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/FinanceFunction.html" title="class in org.apache.poi.ss.formula.functions">FinanceFunction</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Fixed.html" title="class in org.apache.poi.ss.formula.functions">Fixed</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Fixed0ArgFunction.html" title="class in org.apache.poi.ss.formula.functions">Fixed0ArgFunction</a></strong></code>
<div class="block">Convenience base class for functions that only take zero arguments.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Fixed1ArgFunction.html" title="class in org.apache.poi.ss.formula.functions">Fixed1ArgFunction</a></strong></code>
<div class="block">Convenience base class for functions that must take exactly one argument.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Fixed2ArgFunction.html" title="class in org.apache.poi.ss.formula.functions">Fixed2ArgFunction</a></strong></code>
<div class="block">Convenience base class for functions that must take exactly two arguments.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Fixed3ArgFunction.html" title="class in org.apache.poi.ss.formula.functions">Fixed3ArgFunction</a></strong></code>
<div class="block">Convenience base class for functions that must take exactly three arguments.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Fixed4ArgFunction.html" title="class in org.apache.poi.ss.formula.functions">Fixed4ArgFunction</a></strong></code>
<div class="block">Convenience base class for functions that must take exactly four arguments.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Hex2Dec.html" title="class in org.apache.poi.ss.formula.functions">Hex2Dec</a></strong></code>
<div class="block">Implementation for Excel HEX2DEC() function.<p/>
 <p/>
 <b>Syntax</b>:<br/> <b>HEX2DEC  </b>(<b>number</b>)<br/>
 <p/>
 Converts a hexadecimal number to decimal.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Hlookup.html" title="class in org.apache.poi.ss.formula.functions">Hlookup</a></strong></code>
<div class="block">Implementation of the HLOOKUP() function.<p/>

 HLOOKUP finds a column in a lookup table by the first row value and returns the value from another row.<br/>

 <b>Syntax</b>:<br/>
 <b>HLOOKUP</b>(<b>lookup_value</b>, <b>table_array</b>, <b>row_index_num</b>, range_lookup)<p/>

 <b>lookup_value</b>  The value to be found in the first column of the table array.<br/>
 <b>table_array</b> An area reference for the lookup data.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Hyperlink.html" title="class in org.apache.poi.ss.formula.functions">Hyperlink</a></strong></code>
<div class="block">Implementation of Excel HYPERLINK function.<p/>

 In Excel this function has special behaviour - it causes the displayed cell value to behave like
 a hyperlink in the GUI.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/IfFunc.html" title="class in org.apache.poi.ss.formula.functions">IfFunc</a></strong></code>
<div class="block">Implementation for the Excel function IF</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Imaginary.html" title="class in org.apache.poi.ss.formula.functions">Imaginary</a></strong></code>
<div class="block">Implementation for Excel IMAGINARY() function.<p/>
 <p/>
 <b>Syntax</b>:<br/> <b>IMAGINARY  </b>(<b>Inumber</b>)<br/>
 <p/>
 Returns the imaginary coefficient of a complex number in x + yi or x + yj text format.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/ImReal.html" title="class in org.apache.poi.ss.formula.functions">ImReal</a></strong></code>
<div class="block">Implementation for Excel ImReal() function.<p/>
 <p/>
 <b>Syntax</b>:<br/> <b>ImReal  </b>(<b>Inumber</b>)<br/>
 <p/>
 Returns the real coefficient of a complex number in x + yi or x + yj text format.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Index.html" title="class in org.apache.poi.ss.formula.functions">Index</a></strong></code>
<div class="block">Implementation for the Excel function INDEX</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Intercept.html" title="class in org.apache.poi.ss.formula.functions">Intercept</a></strong></code>
<div class="block">Implementation of Excel function INTERCEPT()<p/>

 Calculates the INTERCEPT of the linear regression line that is used to predict y values from x values<br/>
 (http://introcs.cs.princeton.edu/java/97data/LinearRegression.java.html)
 <b>Syntax</b>:<br/>
 <b>INTERCEPT</b>(<b>arrayX</b>, <b>arrayY</b>)<p/></div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/IPMT.html" title="class in org.apache.poi.ss.formula.functions">IPMT</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Irr.html" title="class in org.apache.poi.ss.formula.functions">Irr</a></strong></code>
<div class="block">Calculates the internal rate of return.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/LinearRegressionFunction.html" title="class in org.apache.poi.ss.formula.functions">LinearRegressionFunction</a></strong></code>
<div class="block">Base class for linear regression functions.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/LogicalFunction.html" title="class in org.apache.poi.ss.formula.functions">LogicalFunction</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Lookup.html" title="class in org.apache.poi.ss.formula.functions">Lookup</a></strong></code>
<div class="block">Implementation of Excel function LOOKUP.<p/>

 LOOKUP finds an index  row in a lookup table by the first column value and returns the value from another column.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Match.html" title="class in org.apache.poi.ss.formula.functions">Match</a></strong></code>
<div class="block">Implementation for the MATCH() Excel function.<p/>

 <b>Syntax:</b><br/>
 <b>MATCH</b>(<b>lookup_value</b>, <b>lookup_array</b>, match_type)<p/>

 Returns a 1-based index specifying at what position in the <b>lookup_array</b> the specified
 <b>lookup_value</b> is found.<p/>

 Specific matching behaviour can be modified with the optional <b>match_type</b> parameter.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/MinaMaxa.html" title="class in org.apache.poi.ss.formula.functions">MinaMaxa</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Mirr.html" title="class in org.apache.poi.ss.formula.functions">Mirr</a></strong></code>
<div class="block">Calculates Modified internal rate of return.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Mode.html" title="class in org.apache.poi.ss.formula.functions">Mode</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/MultiOperandNumericFunction.html" title="class in org.apache.poi.ss.formula.functions">MultiOperandNumericFunction</a></strong></code>
<div class="block">This is the super class for all excel function evaluator
 classes that take variable number of operands, and
 where the order of operands does not matter</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Na.html" title="class in org.apache.poi.ss.formula.functions">Na</a></strong></code>
<div class="block">Implementation of Excel function NA()</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NotImplementedFunction.html" title="class in org.apache.poi.ss.formula.functions">NotImplementedFunction</a></strong></code>
<div class="block">This is the default implementation of a Function class.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Now.html" title="class in org.apache.poi.ss.formula.functions">Now</a></strong></code>
<div class="block">Implementation of Excel NOW() Function</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Npv.html" title="class in org.apache.poi.ss.formula.functions">Npv</a></strong></code>
<div class="block">Calculates the net present value of an investment by using a discount rate
 and a series of future payments (negative values) and income (positive
 values).</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html" title="class in org.apache.poi.ss.formula.functions">NumericFunction</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.OneArg.html" title="class in org.apache.poi.ss.formula.functions">NumericFunction.OneArg</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.TwoArg.html" title="class in org.apache.poi.ss.formula.functions">NumericFunction.TwoArg</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Oct2Dec.html" title="class in org.apache.poi.ss.formula.functions">Oct2Dec</a></strong></code>
<div class="block">Implementation for Excel Oct2Dec() function.<p/></div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Odd.html" title="class in org.apache.poi.ss.formula.functions">Odd</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Offset.html" title="class in org.apache.poi.ss.formula.functions">Offset</a></strong></code>
<div class="block">Implementation for Excel function OFFSET()<p/>

 OFFSET returns an area reference that is a specified number of rows and columns from a
 reference cell or area.<p/>

 <b>Syntax</b>:<br/>
 <b>OFFSET</b>(<b>reference</b>, <b>rows</b>, <b>cols</b>, height, width)<p/>
 <b>reference</b> is the base reference.<br/>
 <b>rows</b> is the number of rows up or down from the base reference.<br/>
 <b>cols</b> is the number of columns left or right from the base reference.<br/>
 <b>height</b> (default same height as base reference) is the row count for the returned area reference.<br/>
 <b>width</b> (default same width as base reference) is the column count for the returned area reference.<br/></div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/PPMT.html" title="class in org.apache.poi.ss.formula.functions">PPMT</a></strong></code>
<div class="block">Compute the interest portion of a payment.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Quotient.html" title="class in org.apache.poi.ss.formula.functions">Quotient</a></strong></code>
<div class="block">Implementation for Excel QUOTIENT () function.<p/></div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Rank.html" title="class in org.apache.poi.ss.formula.functions">Rank</a></strong></code>
<div class="block">Returns the rank of a number in a list of numbers.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Rate.html" title="class in org.apache.poi.ss.formula.functions">Rate</a></strong></code>
<div class="block">Implements the Excel Rate function</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Replace.html" title="class in org.apache.poi.ss.formula.functions">Replace</a></strong></code>
<div class="block">An implementation of the Excel REPLACE() function:<p/>
 Replaces part of a text string based on the number of characters
 you specify, with another text string.<br/>

 <b>Syntax</b>:<br/>
 <b>REPLACE</b>(<b>oldText</b>, <b>startNum</b>, <b>numChars</b>, <b>newText</b>)<p/>

 <b>oldText</b>  The text string containing characters to replace<br/>
 <b>startNum</b> The position of the first character to replace (1-based)<br/>
 <b>numChars</b> The number of characters to replace<br/>
 <b>newText</b> The new text value to replace the removed section<br/></div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Rept.html" title="class in org.apache.poi.ss.formula.functions">Rept</a></strong></code>
<div class="block">Implementation for Excel REPT () function.<p/>
 <p/>
 <b>Syntax</b>:<br/> <b>REPT  </b>(<b>text</b>,<b>number_times</b> )<br/>
 <p/>
 Repeats text a given number of times.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Roman.html" title="class in org.apache.poi.ss.formula.functions">Roman</a></strong></code>
<div class="block">Implementation for Excel WeekNum() function.<p/>
 <p/>
 <b>Syntax</b>:<br/> <b>WeekNum  </b>(<b>Serial_num</b>,<b>Return_type</b>)<br/>
 <p/>
 Returns a number that indicates where the week falls numerically within a year.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/RowFunc.html" title="class in org.apache.poi.ss.formula.functions">RowFunc</a></strong></code>
<div class="block">Implementation for the Excel function ROW</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Rows.html" title="class in org.apache.poi.ss.formula.functions">Rows</a></strong></code>
<div class="block">Implementation for Excel ROWS function.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Slope.html" title="class in org.apache.poi.ss.formula.functions">Slope</a></strong></code>
<div class="block">Implementation of Excel function SLOPE()<p/>

 Calculates the SLOPE of the linear regression line that is used to predict y values from x values<br/>
 (http://introcs.cs.princeton.edu/java/97data/LinearRegression.java.html)
 <b>Syntax</b>:<br/>
 <b>SLOPE</b>(<b>arrayX</b>, <b>arrayY</b>)<p/></div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Substitute.html" title="class in org.apache.poi.ss.formula.functions">Substitute</a></strong></code>
<div class="block">An implementation of the SUBSTITUTE function:<P/>
 Substitutes text in a text string with new text, some number of times.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Subtotal.html" title="class in org.apache.poi.ss.formula.functions">Subtotal</a></strong></code>
<div class="block">Implementation for the Excel function SUBTOTAL</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Sumif.html" title="class in org.apache.poi.ss.formula.functions">Sumif</a></strong></code>
<div class="block">Implementation for the Excel function SUMIF</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Sumproduct.html" title="class in org.apache.poi.ss.formula.functions">Sumproduct</a></strong></code>
<div class="block">Implementation for the Excel function SUMPRODUCT</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Sumx2my2.html" title="class in org.apache.poi.ss.formula.functions">Sumx2my2</a></strong></code>
<div class="block">Implementation of Excel function SUMX2MY2()<p/>

 Calculates the sum of differences of squares in two arrays of the same size.<br/>
 <b>Syntax</b>:<br/>
 <b>SUMX2MY2</b>(<b>arrayX</b>, <b>arrayY</b>)<p/>

 result = &Sigma;<sub>i: 0..n</sub>(x<sub>i</sub><sup>2</sup>-y<sub>i</sub><sup>2</sup>)</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Sumx2py2.html" title="class in org.apache.poi.ss.formula.functions">Sumx2py2</a></strong></code>
<div class="block">Implementation of Excel function SUMX2PY2()<p/>

 Calculates the sum of squares in two arrays of the same size.<br/>
 <b>Syntax</b>:<br/>
 <b>SUMX2PY2</b>(<b>arrayX</b>, <b>arrayY</b>)<p/>

 result = &Sigma;<sub>i: 0..n</sub>(x<sub>i</sub><sup>2</sup>+y<sub>i</sub><sup>2</sup>)</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Sumxmy2.html" title="class in org.apache.poi.ss.formula.functions">Sumxmy2</a></strong></code>
<div class="block">Implementation of Excel function SUMXMY2()<p/>

 Calculates the sum of squares of differences between two arrays of the same size.<br/>
 <b>Syntax</b>:<br/>
 <b>SUMXMY2</b>(<b>arrayX</b>, <b>arrayY</b>)<p/>

 result = &Sigma;<sub>i: 0..n</sub>(x<sub>i</sub>-y<sub>i</sub>)<sup>2</sup></div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/T.html" title="class in org.apache.poi.ss.formula.functions">T</a></strong></code>
<div class="block">Implementation of Excel T() function
 <p/>
 If the argument is a text or error value it is returned unmodified.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html" title="class in org.apache.poi.ss.formula.functions">TextFunction</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/TimeFunc.html" title="class in org.apache.poi.ss.formula.functions">TimeFunc</a></strong></code>
<div class="block">Implementation for the Excel function TIME</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Today.html" title="class in org.apache.poi.ss.formula.functions">Today</a></strong></code>
<div class="block">Implementation of Excel TODAY() Function<br/></div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Value.html" title="class in org.apache.poi.ss.formula.functions">Value</a></strong></code>
<div class="block">Implementation for Excel VALUE() function.<p/>

 <b>Syntax</b>:<br/> <b>VALUE</b>(<b>text</b>)<br/>

 Converts the text argument to a number.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/Vlookup.html" title="class in org.apache.poi.ss.formula.functions">Vlookup</a></strong></code>
<div class="block">Implementation of the VLOOKUP() function.<p/>

 VLOOKUP finds a row in a lookup table by the first column value and returns the value from another column.<br/>

 <b>Syntax</b>:<br/>
 <b>VLOOKUP</b>(<b>lookup_value</b>, <b>table_array</b>, <b>col_index_num</b>, range_lookup)<p/>

 <b>lookup_value</b>  The value to be found in the first column of the table array.<br/>
 <b>table_array</b> An area reference for the lookup data.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/WeekdayFunc.html" title="class in org.apache.poi.ss.formula.functions">WeekdayFunc</a></strong></code>
<div class="block">Implementation for the Excel function WEEKDAY</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/WeekNum.html" title="class in org.apache.poi.ss.formula.functions">WeekNum</a></strong></code>
<div class="block">Implementation for Excel WeekNum() function.<p/>
 <p/>
 <b>Syntax</b>:<br/> <b>WeekNum  </b>(<b>Serial_num</b>,<b>Return_type</b>)<br/>
 <p/>
 Returns a number that indicates where the week falls numerically within a year.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>class&nbsp;</code></td>
<td class="colLast"><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/XYNumericFunction.html" title="class in org.apache.poi.ss.formula.functions">XYNumericFunction</a></strong></code>&nbsp;</td>
</tr>
</tbody>
</table>
<table border="0" cellpadding="3" cellspacing="0" summary="Use table, listing fields, and an explanation">
<caption><span>Fields in <a href="../../../../../../../org/apache/poi/ss/formula/functions/package-summary.html">org.apache.poi.ss.formula.functions</a> declared as <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colFirst" scope="col">Modifier and Type</th>
<th class="colLast" scope="col">Field and Description</th>
</tr>
<tbody>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#ABS">ABS</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#ACOS">ACOS</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#ACOSH">ACOSH</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">BooleanFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/BooleanFunction.html#AND">AND</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#ASIN">ASIN</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#ASINH">ASINH</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#ATAN">ATAN</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#ATAN2">ATAN2</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#ATANH">ATANH</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">AggregateFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/AggregateFunction.html#AVEDEV">AVEDEV</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">AggregateFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/AggregateFunction.html#AVERAGE">AVERAGE</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#CEILING">CEILING</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">TextFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#CHAR">CHAR</a></strong></code>
<div class="block">Returns the character specified by a number.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">TextFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#CLEAN">CLEAN</a></strong></code>
<div class="block">An implementation of the CLEAN function:
 In Excel, the Clean function removes all non-printable characters from a string.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#COMBIN">COMBIN</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">TextFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#CONCATENATE">CONCATENATE</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#COS">COS</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#COSH">COSH</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">CalendarFieldFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/CalendarFieldFunction.html#DAY">DAY</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#DEGREES">DEGREES</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">AggregateFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/AggregateFunction.html#DEVSQ">DEVSQ</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#DOLLAR">DOLLAR</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">TextFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#EXACT">EXACT</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#EXP">EXP</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#FACT">FACT</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">BooleanFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/BooleanFunction.html#FALSE">FALSE</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">TextFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#FIND">FIND</a></strong></code>
<div class="block">Implementation of the FIND() function.<p/>

 <b>Syntax</b>:<br/>
 <b>FIND</b>(<b>find_text</b>, <b>within_text</b>, start_num)<p/>

 FIND returns the character position of the first (case sensitive) occurrence of
 <tt>find_text</tt> inside <tt>within_text</tt>.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#FLOOR">FLOOR</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">FinanceFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/FinanceFunction.html#FV">FV</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">CalendarFieldFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/CalendarFieldFunction.html#HOUR">HOUR</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">WeekdayFunc.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/WeekdayFunc.html#instance">instance</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">DateFunc.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/DateFunc.html#instance">instance</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#INT">INT</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">LogicalFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/LogicalFunction.html#ISBLANK">ISBLANK</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">LogicalFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/LogicalFunction.html#ISERROR">ISERROR</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">LogicalFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/LogicalFunction.html#ISLOGICAL">ISLOGICAL</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">LogicalFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/LogicalFunction.html#ISNA">ISNA</a></strong></code>
<div class="block">Implementation for Excel ISNA() function.<p/>

 <b>Syntax</b>:<br/>
 <b>ISNA</b>(<b>value</b>)<p/>

 <b>value</b>  The value to be tested<br/>
 <br/>
 Returns <tt>TRUE</tt> if the specified value is '#N/A', <tt>FALSE</tt> otherwise.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">LogicalFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/LogicalFunction.html#ISNONTEXT">ISNONTEXT</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">LogicalFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/LogicalFunction.html#ISNUMBER">ISNUMBER</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">LogicalFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/LogicalFunction.html#ISREF">ISREF</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">LogicalFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/LogicalFunction.html#ISTEXT">ISTEXT</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">AggregateFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/AggregateFunction.html#LARGE">LARGE</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">TextFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#LEFT">LEFT</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">TextFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#LEN">LEN</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#LN">LN</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#LOG">LOG</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#LOG10">LOG10</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">TextFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#LOWER">LOWER</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">AggregateFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/AggregateFunction.html#MAX">MAX</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">MinaMaxa.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/MinaMaxa.html#MAXA">MAXA</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">AggregateFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/AggregateFunction.html#MEDIAN">MEDIAN</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">TextFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#MID">MID</a></strong></code>
<div class="block">An implementation of the MID function<br/>
 MID returns a specific number of
 characters from a text string, starting at the specified position.<p/>

 <b>Syntax<b>:<br/> <b>MID</b>(<b>text</b>, <b>start_num</b>,
 <b>num_chars</b>)<br/>

 Author: Manda Wilson &lt; wilson at c bio dot msk cc dot org &gt;</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">AggregateFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/AggregateFunction.html#MIN">MIN</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">MinaMaxa.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/MinaMaxa.html#MINA">MINA</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">CalendarFieldFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/CalendarFieldFunction.html#MINUTE">MINUTE</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#MOD">MOD</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">CalendarFieldFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/CalendarFieldFunction.html#MONTH">MONTH</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">BooleanFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/BooleanFunction.html#NOT">NOT</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">FinanceFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/FinanceFunction.html#NPER">NPER</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">BooleanFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/BooleanFunction.html#OR">OR</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">AggregateFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/AggregateFunction.html#PERCENTILE">PERCENTILE</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#PI">PI</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">FinanceFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/FinanceFunction.html#PMT">PMT</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#POISSON">POISSON</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#POWER">POWER</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">AggregateFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/AggregateFunction.html#PRODUCT">PRODUCT</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">TextFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#PROPER">PROPER</a></strong></code>
<div class="block">Implementation of the PROPER function:
 Normalizes all words (separated by non-word characters) by
 making the first letter upper and the rest lower case.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">FinanceFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/FinanceFunction.html#PV">PV</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#RADIANS">RADIANS</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#RAND">RAND</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">TextFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#RIGHT">RIGHT</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#ROUND">ROUND</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#ROUNDDOWN">ROUNDDOWN</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#ROUNDUP">ROUNDUP</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">TextFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#SEARCH">SEARCH</a></strong></code>
<div class="block">Implementation of the FIND() function.<p/>

 <b>Syntax</b>:<br/>
 <b>SEARCH</b>(<b>find_text</b>, <b>within_text</b>, start_num)<p/>

 SEARCH is a case-insensitive version of FIND()</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">CalendarFieldFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/CalendarFieldFunction.html#SECOND">SECOND</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#SIGN">SIGN</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#SIN">SIN</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#SINH">SINH</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">AggregateFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/AggregateFunction.html#SMALL">SMALL</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#SQRT">SQRT</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">AggregateFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/AggregateFunction.html#STDEV">STDEV</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">AggregateFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/AggregateFunction.html#SUM">SUM</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">AggregateFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/AggregateFunction.html#SUMSQ">SUMSQ</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#TAN">TAN</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#TANH">TANH</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">TextFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#TEXT">TEXT</a></strong></code>
<div class="block">An implementation of the TEXT function<br/>
 TEXT returns a number value formatted with the given number formatting string.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">TextFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#TRIM">TRIM</a></strong></code>
<div class="block">An implementation of the TRIM function:
 Removes leading and trailing spaces from value if evaluated operand
  value is string.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">BooleanFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/BooleanFunction.html#TRUE">TRUE</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">NumericFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/NumericFunction.html#TRUNC">TRUNC</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">TextFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/TextFunction.html#UPPER">UPPER</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">AggregateFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/AggregateFunction.html#VAR">VAR</a></strong></code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">AggregateFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/AggregateFunction.html#VARP">VARP</a></strong></code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Function</a></code></td>
<td class="colLast"><span class="strong">CalendarFieldFunction.</span><code><strong><a href="../../../../../../../org/apache/poi/ss/formula/functions/CalendarFieldFunction.html#YEAR">YEAR</a></strong></code>&nbsp;</td>
</tr>
</tbody>
</table>
</li>
</ul>
</li>
</ul>
</div>
<!-- ======= START OF BOTTOM NAVBAR ====== -->
<div class="bottomNav"><a name="navbar_bottom">
<!--   -->
</a><a href="#skip-navbar_bottom" title="Skip navigation links"></a><a name="navbar_bottom_firstrow">
<!--   -->
</a>
<ul class="navList" title="Navigation">
<li><a href="../../../../../../../overview-summary.html">Overview</a></li>
<li><a href="../package-summary.html">Package</a></li>
<li><a href="../../../../../../../org/apache/poi/ss/formula/functions/Function.html" title="interface in org.apache.poi.ss.formula.functions">Class</a></li>
<li class="navBarCell1Rev">Use</li>
<li><a href="../package-tree.html">Tree</a></li>
<li><a href="../../../../../../../deprecated-list.html">Deprecated</a></li>
<li><a href="../../../../../../../index-all.html">Index</a></li>
<li><a href="../../../../../../../help-doc.html">Help</a></li>
</ul>
</div>
<div class="subNav">
<ul class="navList">
<li>PREV</li>
<li>NEXT</li>
</ul>
<ul class="navList">
<li><a href="../../../../../../../index.html?org/apache/poi/ss/formula/functions//class-useFunction.html" target="_top">FRAMES</a></li>
<li><a href="Function.html" target="_top">NO FRAMES</a></li>
</ul>
<ul class="navList" id="allclasses_navbar_bottom">
<li><a href="../../../../../../../allclasses-noframe.html">All Classes</a></li>
</ul>
<div>
<script type="text/javascript"><!--
  allClassesLink = document.getElementById("allclasses_navbar_bottom");
  if(window==top) {
    allClassesLink.style.display = "block";
  }
  else {
    allClassesLink.style.display = "none";
  }
  //-->
</script>
</div>
<a name="skip-navbar_bottom">
<!--   -->
</a></div>
<!-- ======== END OF BOTTOM NAVBAR ======= -->
<p class="legalCopy"><small>
                <i>Copyright 2014 The Apache Software Foundation or
        its licensors, as applicable.</i>
            </small></p>
</body>
</html>
